﻿Public Class CreateTable
    Implements ITable

    Public Function CreateTable(ByVal dbConnection As System.Data.Common.DbConnection, ByVal 前缀 As String) As Boolean Implements IListenDb.ITable.CreateTable

    End Function

    Public Event CreateTableEvent(ByVal table As String) Implements IListenDb.ITable.CreateTableEvent

    Public Function DeleteTable(ByVal dbConnection As System.Data.Common.DbConnection, ByVal 前缀 As String) As Boolean Implements IListenDb.ITable.DeleteTable

    End Function

    Public Event DeleteTableEvent(ByVal table As String) Implements IListenDb.ITable.DeleteTableEvent

    Public Function UpdateTable(ByVal dbConnection As System.Data.Common.DbConnection, ByVal 前缀 As String) As Boolean Implements IListenDb.ITable.UpdateTable

        '添加一个字段
        Dim strsql As String = "alter Table " + 前缀 + "_Control add  X002Status int null"
        CommonConUtil.ExecuteSql(strsql)
        RaiseEvent CreateTableEvent("修改表 " + 前缀 + "_Control")

    End Function

    Public Event UpdateTableEvent(ByVal table As String) Implements IListenDb.ITable.UpdateTableEvent

End Class

